{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='标致')|(price['brand']=='雪铁龙')|(price['brand']=='东风风神')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口雪铁龙>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口标致>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='雪铁龙']\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "\n",
    "LSG = all1[(all1['3']=='LDC')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['东风标致>>', '进口标致>>', '东风风神>>', '东风风神新能源>>', '东风雪铁龙>>', '进口雪铁龙>>',\n",
       "       '东风雪铁龙', '雪铁龙'], dtype=object)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DC7169LSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DC7169LSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1290</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DC7129TSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1275</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98342×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DC7169TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1365</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC98324×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DC7129TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98344×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>DC7129TSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1275</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98342×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>DC7169LSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DC7169LSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1290</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DC7169TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1365</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC98324×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>DC7129TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98344×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>DC7129TSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1275</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98342×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>DC7129TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98344×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>DC7169LSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1290</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>DC7169TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1365</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC98324×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>DC7169LSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>DC7169LSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1290</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>DC7169TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1365</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC98324×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>DC7169LSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC983T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>DC7129TSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1275</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98342×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>DC7129TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC98344×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2675</td>\n",
       "      <td>4590x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致308</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>DC7186LSCB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1365</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LDC973Y4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>DC7166TSCB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1380</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC97324×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>DC7126TSBB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1345</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC97344×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>DC7186LSCN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1310</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LDC973Y2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>DC7126TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC97344×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>DC7166TSBB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1415</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC97324×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>DC7126TSAN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1310</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC97342×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DC7126TSAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1320</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC97344×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DC7186LSBB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1370</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LDC973Y4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>DC7186LSBN</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1315</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1813</td>\n",
       "      <td>102</td>\n",
       "      <td>LDC973Y2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2730</td>\n",
       "      <td>4750x1820x1488</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致408</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>DC6422LLAB16</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1270</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>DC6422TLBB12</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1270</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC67144×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>DC6422LLAM16</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1210</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>DC6422TLBB12</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1270</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC67144×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>DC6422LLAB16</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1270</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>DC6422TLAB12</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1260</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC67144×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>DC6422TLAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1295</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC67124×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>DC6422TLAB</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1295</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC67124×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>DC6422LLCM</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1205</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>DC6422LLCA</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1253</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T3×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>DC6422LLAM</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1205</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>DC6422LLBM</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1205</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>DC6422LLAA</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1253</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T3×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>DC6422LLBA</td>\n",
       "      <td>东风标致</td>\n",
       "      <td>1253</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180</td>\n",
       "      <td>1745</td>\n",
       "      <td>1580</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC671T3×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2540</td>\n",
       "      <td>4180x1745x1580</td>\n",
       "      <td>标致</td>\n",
       "      <td>标致2008</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>DC6432LXAB16</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1260</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>DC6432TXAB12</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1235</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC66144×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>DC6432LXBM</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1210</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>DC6432TXAN12</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1200</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC66142×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>DC6432TXAB</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1270</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC66124×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>DC6432LXAB16</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1260</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T4×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>DC6432LXBM</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1210</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>DC6432LXAA</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1235</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T3×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>DC6432TXAB</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1270</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC66124×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>DC6432LXAM</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1200</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>DC6432TXAN12</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1200</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC66142×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>DC6432TXAB12</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1235</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1199</td>\n",
       "      <td>100</td>\n",
       "      <td>LDC66144×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>DC6432TXAB</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1270</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC66124×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>DC6432LXAM</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1200</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T2×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>DC6432LXAA</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1235</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1587</td>\n",
       "      <td>86</td>\n",
       "      <td>LDC661T3×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>DC6432TXAB</td>\n",
       "      <td>东风雪铁龙</td>\n",
       "      <td>1270</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262</td>\n",
       "      <td>1748</td>\n",
       "      <td>1557</td>\n",
       "      <td>1598</td>\n",
       "      <td>123</td>\n",
       "      <td>LDC66124×××××××××</td>\n",
       "      <td>神龙汽车有限公司</td>\n",
       "      <td>LDC</td>\n",
       "      <td>2655</td>\n",
       "      <td>4262x1748x1557</td>\n",
       "      <td>雪铁龙</td>\n",
       "      <td>雪铁龙C3-XR</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>414 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0      DC7169LSAB    东风标致        1320      2675       4590      1820   \n",
       "1      DC7169LSAN    东风标致        1290      2675       4590      1820   \n",
       "2      DC7129TSAN    东风标致        1275      2675       4590      1820   \n",
       "3      DC7169TSAB    东风标致        1365      2675       4590      1820   \n",
       "4      DC7129TSAB    东风标致        1320      2675       4590      1820   \n",
       "5      DC7129TSAN    东风标致        1275      2675       4590      1820   \n",
       "6      DC7169LSAB    东风标致        1320      2675       4590      1820   \n",
       "7      DC7169LSAN    东风标致        1290      2675       4590      1820   \n",
       "8      DC7169TSAB    东风标致        1365      2675       4590      1820   \n",
       "9      DC7129TSAB    东风标致        1320      2675       4590      1820   \n",
       "10     DC7129TSAN    东风标致        1275      2675       4590      1820   \n",
       "11     DC7129TSAB    东风标致        1320      2675       4590      1820   \n",
       "12     DC7169LSAN    东风标致        1290      2675       4590      1820   \n",
       "13     DC7169TSAB    东风标致        1365      2675       4590      1820   \n",
       "14     DC7169LSAB    东风标致        1320      2675       4590      1820   \n",
       "15     DC7169LSAN    东风标致        1290      2675       4590      1820   \n",
       "16     DC7169TSAB    东风标致        1365      2675       4590      1820   \n",
       "17     DC7169LSAB    东风标致        1320      2675       4590      1820   \n",
       "18     DC7129TSAN    东风标致        1275      2675       4590      1820   \n",
       "19     DC7129TSAB    东风标致        1320      2675       4590      1820   \n",
       "20     DC7186LSCB    东风标致        1365      2730       4750      1820   \n",
       "21     DC7166TSCB    东风标致        1380      2730       4750      1820   \n",
       "22     DC7126TSBB    东风标致        1345      2730       4750      1820   \n",
       "23     DC7186LSCN    东风标致        1310      2730       4750      1820   \n",
       "24     DC7126TSAB    东风标致        1320      2730       4750      1820   \n",
       "25     DC7166TSBB    东风标致        1415      2730       4750      1820   \n",
       "26     DC7126TSAN    东风标致        1310      2730       4750      1820   \n",
       "27     DC7126TSAB    东风标致        1320      2730       4750      1820   \n",
       "28     DC7186LSBB    东风标致        1370      2730       4750      1820   \n",
       "29     DC7186LSBN    东风标致        1315      2730       4750      1820   \n",
       "..            ...     ...         ...       ...        ...       ...   \n",
       "384  DC6422LLAB16    东风标致        1270      2540       4180      1745   \n",
       "385  DC6422TLBB12    东风标致        1270      2540       4180      1745   \n",
       "386  DC6422LLAM16    东风标致        1210      2540       4180      1745   \n",
       "387  DC6422TLBB12    东风标致        1270      2540       4180      1745   \n",
       "388  DC6422LLAB16    东风标致        1270      2540       4180      1745   \n",
       "389  DC6422TLAB12    东风标致        1260      2540       4180      1745   \n",
       "390    DC6422TLAB    东风标致        1295      2540       4180      1745   \n",
       "391    DC6422TLAB    东风标致        1295      2540       4180      1745   \n",
       "392    DC6422LLCM    东风标致        1205      2540       4180      1745   \n",
       "393    DC6422LLCA    东风标致        1253      2540       4180      1745   \n",
       "394    DC6422LLAM    东风标致        1205      2540       4180      1745   \n",
       "395    DC6422LLBM    东风标致        1205      2540       4180      1745   \n",
       "396    DC6422LLAA    东风标致        1253      2540       4180      1745   \n",
       "397    DC6422LLBA    东风标致        1253      2540       4180      1745   \n",
       "398  DC6432LXAB16   东风雪铁龙        1260      2655       4262      1748   \n",
       "399  DC6432TXAB12   东风雪铁龙        1235      2655       4262      1748   \n",
       "400    DC6432LXBM   东风雪铁龙        1210      2655       4262      1748   \n",
       "401  DC6432TXAN12   东风雪铁龙        1200      2655       4262      1748   \n",
       "402    DC6432TXAB   东风雪铁龙        1270      2655       4262      1748   \n",
       "403  DC6432LXAB16   东风雪铁龙        1260      2655       4262      1748   \n",
       "404    DC6432LXBM   东风雪铁龙        1210      2655       4262      1748   \n",
       "405    DC6432LXAA   东风雪铁龙        1235      2655       4262      1748   \n",
       "406    DC6432TXAB   东风雪铁龙        1270      2655       4262      1748   \n",
       "407    DC6432LXAM   东风雪铁龙        1200      2655       4262      1748   \n",
       "408  DC6432TXAN12   东风雪铁龙        1200      2655       4262      1748   \n",
       "409  DC6432TXAB12   东风雪铁龙        1235      2655       4262      1748   \n",
       "410    DC6432TXAB   东风雪铁龙        1270      2655       4262      1748   \n",
       "411    DC6432LXAM   东风雪铁龙        1200      2655       4262      1748   \n",
       "412    DC6432LXAA   东风雪铁龙        1235      2655       4262      1748   \n",
       "413    DC6432TXAB   东风雪铁龙        1270      2655       4262      1748   \n",
       "\n",
       "    car_height Displacement power                vin car_factory    3 轴距[mm]  \\\n",
       "0         1488         1587    86  LDC983T4×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "1         1488         1587    86  LDC983T2×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "2         1488         1199   100  LDC98342×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "3         1488         1598   123  LDC98324×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "4         1488         1199   100  LDC98344×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "5         1488         1199   100  LDC98342×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "6         1488         1587    86  LDC983T4×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "7         1488         1587    86  LDC983T2×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "8         1488         1598   123  LDC98324×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "9         1488         1199   100  LDC98344×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "10        1488         1199   100  LDC98342×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "11        1488         1199   100  LDC98344×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "12        1488         1587    86  LDC983T2×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "13        1488         1598   123  LDC98324×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "14        1488         1587    86  LDC983T4×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "15        1488         1587    86  LDC983T2×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "16        1488         1598   123  LDC98324×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "17        1488         1587    86  LDC983T4×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "18        1488         1199   100  LDC98342×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "19        1488         1199   100  LDC98344×××××××××    神龙汽车有限公司  LDC   2675   \n",
       "20        1488         1813   102  LDC973Y4×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "21        1488         1598   123  LDC97324×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "22        1488         1199   100  LDC97344×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "23        1488         1813   102  LDC973Y2×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "24        1488         1199   100  LDC97344×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "25        1488         1598   123  LDC97324×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "26        1488         1199   100  LDC97342×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "27        1488         1199   100  LDC97344×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "28        1488         1813   102  LDC973Y4×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "29        1488         1813   102  LDC973Y2×××××××××    神龙汽车有限公司  LDC   2730   \n",
       "..         ...          ...   ...                ...         ...  ...    ...   \n",
       "384       1580         1587    86  LDC671T4×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "385       1580         1199   100  LDC67144×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "386       1580         1587    86  LDC671T2×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "387       1580         1199   100  LDC67144×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "388       1580         1587    86  LDC671T4×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "389       1580         1199   100  LDC67144×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "390       1580         1598   123  LDC67124×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "391       1580         1598   123  LDC67124×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "392       1580         1587    86  LDC671T2×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "393       1580         1587    86  LDC671T3×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "394       1580         1587    86  LDC671T2×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "395       1580         1587    86  LDC671T2×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "396       1580         1587    86  LDC671T3×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "397       1580         1587    86  LDC671T3×××××××××    神龙汽车有限公司  LDC   2540   \n",
       "398       1557         1587    86  LDC661T4×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "399       1557         1199   100  LDC66144×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "400       1557         1587    86  LDC661T2×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "401       1557         1199   100  LDC66142×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "402       1557         1598   123  LDC66124×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "403       1557         1587    86  LDC661T4×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "404       1557         1587    86  LDC661T2×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "405       1557         1587    86  LDC661T3×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "406       1557         1598   123  LDC66124×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "407       1557         1587    86  LDC661T2×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "408       1557         1199   100  LDC66142×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "409       1557         1199   100  LDC66144×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "410       1557         1598   123  LDC66124×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "411       1557         1587    86  LDC661T2×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "412       1557         1587    86  LDC661T3×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "413       1557         1598   123  LDC66124×××××××××    神龙汽车有限公司  LDC   2655   \n",
       "\n",
       "          长×宽×高[mm] brand_y     style  factory  \n",
       "0    4590x1820x1488      标致     标致308       12  \n",
       "1    4590x1820x1488      标致     标致308       12  \n",
       "2    4590x1820x1488      标致     标致308       12  \n",
       "3    4590x1820x1488      标致     标致308       12  \n",
       "4    4590x1820x1488      标致     标致308       12  \n",
       "5    4590x1820x1488      标致     标致308       12  \n",
       "6    4590x1820x1488      标致     标致308       12  \n",
       "7    4590x1820x1488      标致     标致308       12  \n",
       "8    4590x1820x1488      标致     标致308       12  \n",
       "9    4590x1820x1488      标致     标致308       12  \n",
       "10   4590x1820x1488      标致     标致308       12  \n",
       "11   4590x1820x1488      标致     标致308       12  \n",
       "12   4590x1820x1488      标致     标致308       12  \n",
       "13   4590x1820x1488      标致     标致308       12  \n",
       "14   4590x1820x1488      标致     标致308       12  \n",
       "15   4590x1820x1488      标致     标致308       12  \n",
       "16   4590x1820x1488      标致     标致308       12  \n",
       "17   4590x1820x1488      标致     标致308       12  \n",
       "18   4590x1820x1488      标致     标致308       12  \n",
       "19   4590x1820x1488      标致     标致308       12  \n",
       "20   4750x1820x1488      标致     标致408       21  \n",
       "21   4750x1820x1488      标致     标致408       21  \n",
       "22   4750x1820x1488      标致     标致408       21  \n",
       "23   4750x1820x1488      标致     标致408       21  \n",
       "24   4750x1820x1488      标致     标致408       21  \n",
       "25   4750x1820x1488      标致     标致408       21  \n",
       "26   4750x1820x1488      标致     标致408       21  \n",
       "27   4750x1820x1488      标致     标致408       21  \n",
       "28   4750x1820x1488      标致     标致408       21  \n",
       "29   4750x1820x1488      标致     标致408       21  \n",
       "..              ...     ...       ...      ...  \n",
       "384  4180x1745x1580      标致    标致2008       23  \n",
       "385  4180x1745x1580      标致    标致2008       23  \n",
       "386  4180x1745x1580      标致    标致2008       23  \n",
       "387  4180x1745x1580      标致    标致2008       23  \n",
       "388  4180x1745x1580      标致    标致2008       23  \n",
       "389  4180x1745x1580      标致    标致2008       23  \n",
       "390  4180x1745x1580      标致    标致2008       23  \n",
       "391  4180x1745x1580      标致    标致2008       23  \n",
       "392  4180x1745x1580      标致    标致2008       23  \n",
       "393  4180x1745x1580      标致    标致2008       23  \n",
       "394  4180x1745x1580      标致    标致2008       23  \n",
       "395  4180x1745x1580      标致    标致2008       23  \n",
       "396  4180x1745x1580      标致    标致2008       23  \n",
       "397  4180x1745x1580      标致    标致2008       23  \n",
       "398  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "399  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "400  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "401  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "402  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "403  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "404  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "405  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "406  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "407  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "408  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "409  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "410  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "411  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "412  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "413  4262x1748x1557     雪铁龙  雪铁龙C3-XR       24  \n",
       "\n",
       "[414 rows x 17 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('标致_雪铁龙_风神_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
